Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 383245 |
| Missing cells | 475363 |
| Missing cells (%) | 4.8% |
| Duplicate rows | 22637 |
| Duplicate rows (%) | 5.9% |
| Total size in memory | 76.0 MiB |
| Average record size in memory | 208.0 B |
Variable types
| CAT | 16 |
|---|---|
| NUM | 10 |
Reproduction
| Analysis started | 2021-11-08 10:27:55.336769 |
|---|---|
| Analysis finished | 2021-11-08 10:30:20.251279 |
| Duration | 2 minutes and 24.91 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
RECORD DATE has constant value "11/07/2021" | Constant |
| Dataset has 22637 (5.9%) duplicate rows | Duplicates |
DBA has a high cardinality: 22984 distinct values | High cardinality |
BUILDING has a high cardinality: 7681 distinct values | High cardinality |
STREET has a high cardinality: 2473 distinct values | High cardinality |
PHONE has a high cardinality: 27299 distinct values | High cardinality |
CUISINE DESCRIPTION has a high cardinality: 86 distinct values | High cardinality |
INSPECTION DATE has a high cardinality: 1509 distinct values | High cardinality |
VIOLATION CODE has a high cardinality: 105 distinct values | High cardinality |
VIOLATION DESCRIPTION has a high cardinality: 106 distinct values | High cardinality |
GRADE DATE has a high cardinality: 1340 distinct values | High cardinality |
NTA has a high cardinality: 193 distinct values | High cardinality |
Longitude is highly correlated with Latitude | High correlation |
Latitude is highly correlated with Longitude | High correlation |
BIN is highly correlated with Community Board and 1 other fields | High correlation |
Community Board is highly correlated with BIN and 1 other fields | High correlation |
BBL is highly correlated with Community Board and 1 other fields | High correlation |
ZIPCODE has 5606 (1.5%) missing values | Missing |
CUISINE DESCRIPTION has 4415 (1.2%) missing values | Missing |
ACTION has 4414 (1.2%) missing values | Missing |
VIOLATION CODE has 9069 (2.4%) missing values | Missing |
VIOLATION DESCRIPTION has 6633 (1.7%) missing values | Missing |
SCORE has 17949 (4.7%) missing values | Missing |
GRADE has 189746 (49.5%) missing values | Missing |
GRADE DATE has 194484 (50.7%) missing values | Missing |
INSPECTION TYPE has 4414 (1.2%) missing values | Missing |
Community Board has 6621 (1.7%) missing values | Missing |
Council District has 6621 (1.7%) missing values | Missing |
Census Tract has 6621 (1.7%) missing values | Missing |
BIN has 8384 (2.2%) missing values | Missing |
NTA has 6621 (1.7%) missing values | Missing |
Latitude has 5581 (1.5%) zeros | Zeros |
Longitude has 5581 (1.5%) zeros | Zeros |
CAMIS
Real number (ℝ≥0)
| Distinct count | 29824 |
|---|---|
| Unique (%) | 7.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46443726.55225248 |
|---|---|
| Minimum | 30075445 |
| Maximum | 50116984 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 30075445 |
|---|---|
| 5-th percentile | 40567158 |
| Q1 | 41442734 |
| median | 50013536 |
| Q3 | 50064308 |
| 95-th percentile | 50095010 |
| Maximum | 50116984 |
| Range | 20041539 |
| Interquartile range (IQR) | 8621574 |
Descriptive statistics
| Standard deviation | 4356588.875 |
|---|---|
| Coefficient of variation (CV) | 0.09380360273 |
| Kurtosis | -1.820673534 |
| Mean | 46443726.55 |
| Median Absolute Deviation (MAD) | 72922 |
| Skewness | -0.3882643003 |
| Sum | 1.779932598e+13 |
| Variance | 1.897986662e+13 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 50035784 | 104 | < 0.1% | |
| 40400811 | 99 | < 0.1% | |
| 41187577 | 87 | < 0.1% | |
| 41683816 | 87 | < 0.1% | |
| 41409441 | 85 | < 0.1% | |
| 50001789 | 84 | < 0.1% | |
| 41425803 | 83 | < 0.1% | |
| 41474882 | 83 | < 0.1% | |
| 50064654 | 82 | < 0.1% | |
| 50012113 | 82 | < 0.1% | |
| Other values (29814) | 382369 | 99.8% |
| Value | Count | Frequency (%) | |
| 30075445 | 12 | < 0.1% | |
| 30112340 | 12 | < 0.1% | |
| 30191841 | 10 | < 0.1% | |
| 40356018 | 11 | < 0.1% | |
| 40356483 | 9 | < 0.1% |
| Value | Count | Frequency (%) | |
| 50116984 | 1 | < 0.1% | |
| 50116983 | 1 | < 0.1% | |
| 50116981 | 1 | < 0.1% | |
| 50116980 | 1 | < 0.1% | |
| 50116979 | 1 | < 0.1% |
| Distinct count | 22984 |
|---|---|
| Unique (%) | 6.0% |
| Missing | 1169 |
| Missing (%) | 0.3% |
| Memory size | 2.9 MiB |
| DUNKIN | 4068 |
|---|---|
| SUBWAY | 2664 |
| STARBUCKS | 1990 |
| MCDONALD'S | 1876 |
| KENNEDY FRIED CHICKEN | 1209 |
| Other values (22979) |
| Value | Count | Frequency (%) | |
| DUNKIN | 4068 | 1.1% | |
| SUBWAY | 2664 | 0.7% | |
| STARBUCKS | 1990 | 0.5% | |
| MCDONALD'S | 1876 | 0.5% | |
| KENNEDY FRIED CHICKEN | 1209 | 0.3% | |
| CROWN FRIED CHICKEN | 1046 | 0.3% | |
| BURGER KING | 1019 | 0.3% | |
| POPEYES | 862 | 0.2% | |
| GOLDEN KRUST CARIBBEAN BAKERY & GRILL | 844 | 0.2% | |
| DUNKIN',' BASKIN ROBBINS | 653 | 0.2% | |
| Other values (22974) | 365845 | 95.5% | |
| (Missing) | 1169 | 0.3% |
Length
| Max length | 95 |
|---|---|
| Median length | 15 |
| Mean length | 16.36179728 |
| Min length | 2 |
BORO
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| Manhattan | |
|---|---|
| Brooklyn | |
| Queens | |
| Bronx | |
| Staten Island | 12238 |
| Value | Count | Frequency (%) | |
| Manhattan | 149713 | 39.1% | |
| Brooklyn | 96998 | 25.3% | |
| Queens | 88594 | 23.1% | |
| Bronx | 35584 | 9.3% | |
| Staten Island | 12238 | 3.2% | |
| 0 | 118 | < 0.1% |
Length
| Max length | 13 |
|---|---|
| Median length | 8 |
| Mean length | 7.807269501 |
| Min length | 1 |
| Distinct count | 7681 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 737 |
| Missing (%) | 0.2% |
| Memory size | 2.9 MiB |
| 1 | 2255 |
|---|---|
| 200 | 1266 |
| 2 | 1218 |
| 0 | 1110 |
| 10 | 1049 |
| Other values (7676) |
| Value | Count | Frequency (%) | |
| 1 | 2255 | 0.6% | |
| 200 | 1266 | 0.3% | |
| 2 | 1218 | 0.3% | |
| 0 | 1110 | 0.3% | |
| 10 | 1049 | 0.3% | |
| 55 | 1017 | 0.3% | |
| 25 | 937 | 0.2% | |
| 11 | 888 | 0.2% | |
| 75 | 881 | 0.2% | |
| 60 | 873 | 0.2% | |
| Other values (7671) | 371014 | 96.8% |
Length
| Max length | 10 |
|---|---|
| Median length | 3 |
| Mean length | 3.454229018 |
| Min length | 1 |
| Distinct count | 2473 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 25 |
| Missing (%) | < 0.1% |
| Memory size | 2.9 MiB |
| BROADWAY | 13811 |
|---|---|
| 3 AVENUE | 8349 |
| 2 AVENUE | 6655 |
| 5 AVENUE | 6601 |
| 8 AVENUE | 5538 |
| Other values (2468) |
| Value | Count | Frequency (%) | |
| BROADWAY | 13811 | 3.6% | |
| 3 AVENUE | 8349 | 2.2% | |
| 2 AVENUE | 6655 | 1.7% | |
| 5 AVENUE | 6601 | 1.7% | |
| 8 AVENUE | 5538 | 1.4% | |
| 1 AVENUE | 5096 | 1.3% | |
| 7 AVENUE | 4581 | 1.2% | |
| AMSTERDAM AVENUE | 4352 | 1.1% | |
| LEXINGTON AVENUE | 4292 | 1.1% | |
| 9 AVENUE | 4173 | 1.1% | |
| Other values (2463) | 319772 | 83.4% |
Length
| Max length | 40 |
|---|---|
| Median length | 13 |
| Mean length | 13.0911323 |
| Min length | 3 |
| Distinct count | 229 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 5606 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10682.982525639565 |
|---|---|
| Minimum | 10000.0 |
| Maximum | 30339.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 10003 |
| Q1 | 10022 |
| median | 10469 |
| Q3 | 11229 |
| 95-th percentile | 11417 |
| Maximum | 30339 |
| Range | 20339 |
| Interquartile range (IQR) | 1207 |
Descriptive statistics
| Standard deviation | 602.0356606 |
|---|---|
| Coefficient of variation (CV) | 0.05635464245 |
| Kurtosis | 19.34759036 |
| Mean | 10682.98253 |
| Median Absolute Deviation (MAD) | 468 |
| Skewness | 0.6366501274 |
| Sum | 4034310838 |
| Variance | 362446.9366 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 10003 | 9541 | 2.5% | |
| 10019 | 9178 | 2.4% | |
| 10036 | 8220 | 2.1% | |
| 10002 | 8048 | 2.1% | |
| 10013 | 7940 | 2.1% | |
| 10001 | 6821 | 1.8% | |
| 11220 | 6711 | 1.8% | |
| 10016 | 6547 | 1.7% | |
| 11354 | 6492 | 1.7% | |
| 10022 | 6492 | 1.7% | |
| Other values (219) | 301649 | 78.7% |
| Value | Count | Frequency (%) | |
| 10000 | 30 | < 0.1% | |
| 10001 | 6821 | 1.8% | |
| 10002 | 8048 | 2.1% | |
| 10003 | 9541 | 2.5% | |
| 10004 | 1931 | 0.5% |
| Value | Count | Frequency (%) | |
| 30339 | 7 | < 0.1% | |
| 20147 | 1 | < 0.1% | |
| 12345 | 11 | < 0.1% | |
| 11697 | 51 | < 0.1% | |
| 11694 | 375 | 0.1% |
| Distinct count | 27299 |
|---|---|
| Unique (%) | 7.1% |
| Missing | 28 |
| Missing (%) | < 0.1% |
| Memory size | 2.9 MiB |
| 7185958100 | 297 |
|---|---|
| __________ | 175 |
| 2126159700 | 168 |
| 7182246030 | 160 |
| 9176186310 | 155 |
| Other values (27294) |
| Value | Count | Frequency (%) | |
| 7185958100 | 297 | 0.1% | |
| __________ | 175 | < 0.1% | |
| 2126159700 | 168 | < 0.1% | |
| 7182246030 | 160 | < 0.1% | |
| 9176186310 | 155 | < 0.1% | |
| 2124656273 | 155 | < 0.1% | |
| 9172843260 | 150 | < 0.1% | |
| 9175665727 | 142 | < 0.1% | |
| 7182153308 | 138 | < 0.1% | |
| 6463218563 | 135 | < 0.1% | |
| Other values (27289) | 381542 | 99.6% |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 9.99959295 |
| Min length | 3 |
| Distinct count | 86 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 4415 |
| Missing (%) | 1.2% |
| Memory size | 2.9 MiB |
| American | |
|---|---|
| Chinese | 39789 |
| Pizza | 23452 |
| Coffee/Tea | 18882 |
| Latin American | 17121 |
| Other values (81) |
| Value | Count | Frequency (%) | |
| American | 73129 | 19.1% | |
| Chinese | 39789 | 10.4% | |
| Pizza | 23452 | 6.1% | |
| Coffee/Tea | 18882 | 4.9% | |
| Latin American | 17121 | 4.5% | |
| Italian | 15634 | 4.1% | |
| Mexican | 14126 | 3.7% | |
| Japanese | 14043 | 3.7% | |
| Caribbean | 13920 | 3.6% | |
| Bakery Products/Desserts | 11737 | 3.1% | |
| Other values (76) | 136997 | 35.7% |
Length
| Max length | 30 |
|---|---|
| Median length | 8 |
| Mean length | 9.226194732 |
| Min length | 3 |
| Distinct count | 1509 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| 01/01/1900 | 4414 |
|---|---|
| 11/07/2019 | 846 |
| 03/28/2019 | 833 |
| 10/30/2019 | 821 |
| 10/23/2019 | 802 |
| Other values (1504) |
| Value | Count | Frequency (%) | |
| 01/01/1900 | 4414 | 1.2% | |
| 11/07/2019 | 846 | 0.2% | |
| 03/28/2019 | 833 | 0.2% | |
| 10/30/2019 | 821 | 0.2% | |
| 10/23/2019 | 802 | 0.2% | |
| 11/13/2019 | 799 | 0.2% | |
| 03/03/2020 | 790 | 0.2% | |
| 09/11/2019 | 789 | 0.2% | |
| 01/14/2020 | 785 | 0.2% | |
| 01/22/2020 | 779 | 0.2% | |
| Other values (1499) | 371587 | 97.0% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 4414 |
| Missing (%) | 1.2% |
| Memory size | 2.9 MiB |
| Violations were cited in the following area(s). | |
|---|---|
| Establishment Closed by DOHMH. Violations were cited in the following area(s) and those requiring immediate action were addressed. | 15024 |
| No violations were recorded at the time of this inspection. | 4552 |
| Establishment re-opened by DOHMH. | 4241 |
| Establishment re-closed by DOHMH. | 66 |
| Value | Count | Frequency (%) | |
| Violations were cited in the following area(s). | 354948 | 92.6% | |
| Establishment Closed by DOHMH. Violations were cited in the following area(s) and those requiring immediate action were addressed. | 15024 | 3.9% | |
| No violations were recorded at the time of this inspection. | 4552 | 1.2% | |
| Establishment re-opened by DOHMH. | 4241 | 1.1% | |
| Establishment re-closed by DOHMH. | 66 | < 0.1% | |
| (Missing) | 4414 | 1.2% |
Length
| Max length | 130 |
|---|---|
| Median length | 47 |
| Mean length | 49.73220003 |
| Min length | 3 |
| Distinct count | 105 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 9069 |
| Missing (%) | 2.4% |
| Memory size | 2.9 MiB |
| 10F | |
|---|---|
| 08A | |
| 04L | 26426 |
| 06D | 24480 |
| 06C | 23881 |
| Other values (100) |
| Value | Count | Frequency (%) | |
| 10F | 65389 | 17.1% | |
| 08A | 40111 | 10.5% | |
| 04L | 26426 | 6.9% | |
| 06D | 24480 | 6.4% | |
| 06C | 23881 | 6.2% | |
| 10B | 22593 | 5.9% | |
| 02G | 22360 | 5.8% | |
| 04N | 19537 | 5.1% | |
| 02B | 18164 | 4.7% | |
| 04M | 8007 | 2.1% | |
| Other values (95) | 103228 | 26.9% | |
| (Missing) | 9069 | 2.4% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.004634111 |
| Min length | 3 |
| Distinct count | 106 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 6633 |
| Missing (%) | 1.7% |
| Memory size | 2.9 MiB |
| Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | |
|---|---|
| Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist. | |
| Evidence of mice or live mice present in facility's food and/or non-food areas. | 26476 |
| Food contact surface not properly washed, rinsed and sanitized after each use and following any activity when contamination may have occurred. | 24561 |
| Food not protected from potential source of contamination during storage, preparation, transportation, display or service. | 24025 |
| Other values (101) |
| Value | Count | Frequency (%) | |
| Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | 65510 | 17.1% | |
| Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist. | 40190 | 10.5% | |
| Evidence of mice or live mice present in facility's food and/or non-food areas. | 26476 | 6.9% | |
| Food contact surface not properly washed, rinsed and sanitized after each use and following any activity when contamination may have occurred. | 24561 | 6.4% | |
| Food not protected from potential source of contamination during storage, preparation, transportation, display or service. | 24025 | 6.3% | |
| Plumbing not properly installed or maintained; anti-siphonage or backflow prevention device not provided where required; equipment or floor not properly drained; sewage disposal system in disrepair or not functioning properly. | 22630 | 5.9% | |
| Cold food item held above 41º F (smoked fish and reduced oxygen packaged foods above 38 ºF) except during necessary preparation. | 22475 | 5.9% | |
| Filth flies or food/refuse/sewage-associated (FRSA) flies present in facility’s food and/or non-food areas. Filth flies include house flies, little house flies, blow flies, bottle flies and flesh flies. Food/refuse/sewage-associated flies include fruit flies, drain flies and Phorid flies. | 19564 | 5.1% | |
| Hot food item not held at or above 140º F. | 18252 | 4.8% | |
| Live roaches present in facility's food and/or non-food areas. | 8013 | 2.1% | |
| Other values (96) | 104916 | 27.4% |
Length
| Max length | 360 |
|---|---|
| Median length | 130 |
| Mean length | 150.2514084 |
| Min length | 3 |
CRITICAL FLAG
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| Critical | |
|---|---|
| Not Critical | |
| Not Applicable | 6633 |
| Value | Count | Frequency (%) | |
| Critical | 201359 | 52.5% | |
| Not Critical | 175253 | 45.7% | |
| Not Applicable | 6633 | 1.7% |
Length
| Max length | 14 |
|---|---|
| Median length | 8 |
| Mean length | 9.932993255 |
| Min length | 8 |
| Distinct count | 136 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 17949 |
| Missing (%) | 4.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.411723643292014 |
|---|---|
| Minimum | 0.0 |
| Maximum | 164.0 |
| Zeros | 2395 |
| Zeros (%) | 0.6% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 11 |
| median | 15 |
| Q3 | 26 |
| 95-th percentile | 50 |
| Maximum | 164 |
| Range | 164 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 14.98849076 |
|---|---|
| Coefficient of variation (CV) | 0.734307941 |
| Kurtosis | 6.51255858 |
| Mean | 20.41172364 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.028946687 |
| Sum | 7456321 |
| Variance | 224.6548553 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 12 | 38698 | 10.1% | |
| 13 | 32111 | 8.4% | |
| 10 | 21153 | 5.5% | |
| 11 | 19997 | 5.2% | |
| 9 | 18131 | 4.7% | |
| 7 | 13200 | 3.4% | |
| 19 | 9908 | 2.6% | |
| 20 | 9804 | 2.6% | |
| 21 | 9293 | 2.4% | |
| 22 | 9222 | 2.4% | |
| Other values (126) | 183779 | 48.0% | |
| (Missing) | 17949 | 4.7% |
| Value | Count | Frequency (%) | |
| 0 | 2395 | 0.6% | |
| 2 | 4389 | 1.1% | |
| 3 | 2992 | 0.8% | |
| 4 | 4600 | 1.2% | |
| 5 | 6518 | 1.7% |
| Value | Count | Frequency (%) | |
| 164 | 11 | < 0.1% | |
| 157 | 14 | < 0.1% | |
| 153 | 11 | < 0.1% | |
| 151 | 10 | < 0.1% | |
| 150 | 9 | < 0.1% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 189746 |
| Missing (%) | 49.5% |
| Memory size | 2.9 MiB |
| A | |
|---|---|
| B | 23596 |
| C | 9242 |
| N | 4745 |
| P | 2493 |
| Other values (2) | 1208 |
| Value | Count | Frequency (%) | |
| A | 152215 | 39.7% | |
| B | 23596 | 6.2% | |
| C | 9242 | 2.4% | |
| N | 4745 | 1.2% | |
| P | 2493 | 0.7% | |
| Z | 1207 | 0.3% | |
| G | 1 | < 0.1% | |
| (Missing) | 189746 | 49.5% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.990207309 |
| Min length | 1 |
| Distinct count | 1340 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 194484 |
| Missing (%) | 50.7% |
| Memory size | 2.9 MiB |
| 06/05/2019 | 496 |
|---|---|
| 06/13/2019 | 479 |
| 06/11/2019 | 474 |
| 05/09/2019 | 469 |
| 06/12/2019 | 460 |
| Other values (1335) |
| Value | Count | Frequency (%) | |
| 06/05/2019 | 496 | 0.1% | |
| 06/13/2019 | 479 | 0.1% | |
| 06/11/2019 | 474 | 0.1% | |
| 05/09/2019 | 469 | 0.1% | |
| 06/12/2019 | 460 | 0.1% | |
| 05/30/2019 | 451 | 0.1% | |
| 08/01/2019 | 445 | 0.1% | |
| 11/07/2019 | 440 | 0.1% | |
| 06/04/2019 | 429 | 0.1% | |
| 05/01/2019 | 429 | 0.1% | |
| Other values (1330) | 184189 | 48.1% | |
| (Missing) | 194484 | 50.7% |
Length
| Max length | 10 |
|---|---|
| Median length | 3 |
| Mean length | 6.447734478 |
| Min length | 3 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| 11/07/2021 |
|---|
| Value | Count | Frequency (%) | |
| 11/07/2021 | 383245 | 100.0% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct count | 31 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 4414 |
| Missing (%) | 1.2% |
| Memory size | 2.9 MiB |
| Cycle Inspection / Initial Inspection | |
|---|---|
| Cycle Inspection / Re-inspection | |
| Pre-permit (Operational) / Initial Inspection | 31196 |
| Pre-permit (Operational) / Re-inspection | 12135 |
| Administrative Miscellaneous / Initial Inspection | 6835 |
| Other values (26) | 18619 |
| Value | Count | Frequency (%) | |
| Cycle Inspection / Initial Inspection | 223096 | 58.2% | |
| Cycle Inspection / Re-inspection | 86950 | 22.7% | |
| Pre-permit (Operational) / Initial Inspection | 31196 | 8.1% | |
| Pre-permit (Operational) / Re-inspection | 12135 | 3.2% | |
| Administrative Miscellaneous / Initial Inspection | 6835 | 1.8% | |
| Cycle Inspection / Reopening Inspection | 4147 | 1.1% | |
| Pre-permit (Non-operational) / Initial Inspection | 3334 | 0.9% | |
| Smoke-Free Air Act / Initial Inspection | 1756 | 0.5% | |
| Administrative Miscellaneous / Re-inspection | 1668 | 0.4% | |
| Trans Fat / Initial Inspection | 1294 | 0.3% | |
| Other values (21) | 6420 | 1.7% | |
| (Missing) | 4414 | 1.2% |
Length
| Max length | 59 |
|---|---|
| Median length | 37 |
| Mean length | 36.66562904 |
| Min length | 3 |
| Distinct count | 23574 |
|---|---|
| Unique (%) | 6.2% |
| Missing | 383 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.135671666060155 |
|---|---|
| Minimum | 0.0 |
| Maximum | 40.912822326386 |
| Zeros | 5581 |
| Zeros (%) | 1.5% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 40.60039481 |
| Q1 | 40.6864742 |
| median | 40.73281684 |
| Q3 | 40.76202067 |
| 95-th percentile | 40.85213353 |
| Maximum | 40.91282233 |
| Range | 40.91282233 |
| Interquartile range (IQR) | 0.0755464773 |
Descriptive statistics
| Standard deviation | 4.881977637 |
|---|---|
| Coefficient of variation (CV) | 0.121636874 |
| Kurtosis | 63.59138685 |
| Mean | 40.13567167 |
| Median Absolute Deviation (MAD) | 0.03424014662 |
| Skewness | -8.098016739 |
| Sum | 15366423.53 |
| Variance | 23.83370565 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 5581 | 1.5% | |
| 40.64831283 | 1068 | 0.3% | |
| 40.75977791 | 478 | 0.1% | |
| 40.73384018 | 437 | 0.1% | |
| 40.758502 | 356 | 0.1% | |
| 40.74186904 | 356 | 0.1% | |
| 40.58229742 | 352 | 0.1% | |
| 40.77441403 | 334 | 0.1% | |
| 40.86590541 | 283 | 0.1% | |
| 40.75209393 | 265 | 0.1% | |
| Other values (23564) | 373352 | 97.4% | |
| (Missing) | 383 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 5581 | 1.5% | |
| 40.49956271 | 1 | < 0.1% | |
| 40.50806852 | 10 | < 0.1% | |
| 40.50911465 | 17 | < 0.1% | |
| 40.50913582 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 40.91282233 | 15 | < 0.1% | |
| 40.91055829 | 7 | < 0.1% | |
| 40.91047336 | 16 | < 0.1% | |
| 40.91001188 | 1 | < 0.1% | |
| 40.90982301 | 1 | < 0.1% |
| Distinct count | 23574 |
|---|---|
| Unique (%) | 6.2% |
| Missing | 383 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -72.86426071780869 |
|---|---|
| Minimum | -74.249101331725 |
| Maximum | 0.0 |
| Zeros | 5581 |
| Zeros (%) | 1.5% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | -74.24910133 |
|---|---|
| 5-th percentile | -74.01347541 |
| Q1 | -73.9888196 |
| median | -73.95731359 |
| Q3 | -73.89735664 |
| 95-th percentile | -73.79009475 |
| Maximum | 0 |
| Range | 74.24910133 |
| Interquartile range (IQR) | 0.09146296512 |
Descriptive statistics
| Standard deviation | 8.86244733 |
|---|---|
| Coefficient of variation (CV) | -0.1216295512 |
| Kurtosis | 63.60741425 |
| Mean | -72.86426072 |
| Median Absolute Deviation (MAD) | 0.03786817541 |
| Skewness | 8.099523347 |
| Sum | -27896956.59 |
| Variance | 78.54297268 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 5581 | 1.5% | |
| -73.7882815 | 1068 | 0.3% | |
| -73.82923543 | 478 | 0.1% | |
| -73.87157703 | 437 | 0.1% | |
| -74.00471301 | 356 | 0.1% | |
| -73.83324181 | 356 | 0.1% | |
| -74.16905259 | 352 | 0.1% | |
| -73.87729335 | 334 | 0.1% | |
| -73.83042975 | 283 | 0.1% | |
| -73.97760435 | 265 | 0.1% | |
| Other values (23564) | 373352 | 97.4% | |
| (Missing) | 383 | 0.1% |
| Value | Count | Frequency (%) | |
| -74.24910133 | 1 | < 0.1% | |
| -74.24870792 | 6 | < 0.1% | |
| -74.24850215 | 1 | < 0.1% | |
| -74.24843447 | 4 | < 0.1% | |
| -74.24837218 | 15 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 5581 | 1.5% | |
| -73.70092806 | 16 | < 0.1% | |
| -73.70171187 | 24 | < 0.1% | |
| -73.70266685 | 21 | < 0.1% | |
| -73.70268132 | 2 | < 0.1% |
| Distinct count | 69 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 6621 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 248.75987456986277 |
|---|---|
| Minimum | 101.0 |
| Maximum | 595.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 101 |
|---|---|
| 5-th percentile | 102 |
| Q1 | 105 |
| median | 301 |
| Q3 | 401 |
| 95-th percentile | 412 |
| Maximum | 595 |
| Range | 494 |
| Interquartile range (IQR) | 296 |
Descriptive statistics
| Standard deviation | 130.1658143 |
|---|---|
| Coefficient of variation (CV) | 0.5232588839 |
| Kurtosis | -1.432718466 |
| Mean | 248.7598746 |
| Median Absolute Deviation (MAD) | 106 |
| Skewness | 0.1538379583 |
| Sum | 93688939 |
| Variance | 16943.13922 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 105 | 30810 | 8.0% | |
| 103 | 20326 | 5.3% | |
| 102 | 18043 | 4.7% | |
| 104 | 15371 | 4.0% | |
| 407 | 13529 | 3.5% | |
| 106 | 12622 | 3.3% | |
| 301 | 12123 | 3.2% | |
| 108 | 11650 | 3.0% | |
| 401 | 11323 | 3.0% | |
| 101 | 10962 | 2.9% | |
| Other values (59) | 219865 | 57.4% |
| Value | Count | Frequency (%) | |
| 101 | 10962 | 2.9% | |
| 102 | 18043 | 4.7% | |
| 103 | 20326 | 5.3% | |
| 104 | 15371 | 4.0% | |
| 105 | 30810 | 8.0% |
| Value | Count | Frequency (%) | |
| 595 | 11 | < 0.1% | |
| 503 | 2916 | 0.8% | |
| 502 | 3708 | 1.0% | |
| 501 | 5403 | 1.4% | |
| 483 | 660 | 0.2% |
| Distinct count | 51 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 6621 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.000985067335062 |
|---|---|
| Minimum | 1.0 |
| Maximum | 51.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 20 |
| Q3 | 34 |
| 95-th percentile | 47 |
| Maximum | 51 |
| Range | 50 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 15.70688938 |
|---|---|
| Coefficient of variation (CV) | 0.7853057898 |
| Kurtosis | -1.282555491 |
| Mean | 20.00098507 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 0.3075293446 |
| Sum | 7532851 |
| Variance | 246.7063738 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 3 | 33078 | 8.6% | |
| 1 | 29743 | 7.8% | |
| 4 | 29221 | 7.6% | |
| 2 | 19894 | 5.2% | |
| 33 | 12159 | 3.2% | |
| 20 | 10993 | 2.9% | |
| 34 | 10663 | 2.8% | |
| 26 | 10268 | 2.7% | |
| 38 | 10216 | 2.7% | |
| 39 | 9551 | 2.5% | |
| Other values (41) | 200838 | 52.4% |
| Value | Count | Frequency (%) | |
| 1 | 29743 | 7.8% | |
| 2 | 19894 | 5.2% | |
| 3 | 33078 | 8.6% | |
| 4 | 29221 | 7.6% | |
| 5 | 8366 | 2.2% |
| Value | Count | Frequency (%) | |
| 51 | 3418 | 0.9% | |
| 50 | 3762 | 1.0% | |
| 49 | 4858 | 1.3% | |
| 48 | 4705 | 1.2% | |
| 47 | 5112 | 1.3% |
| Distinct count | 1190 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 6621 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28842.442327095458 |
|---|---|
| Minimum | 100.0 |
| Maximum | 162100.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 1800 |
| Q1 | 8000 |
| median | 16300 |
| Q3 | 40500 |
| 95-th percentile | 93000 |
| Maximum | 162100 |
| Range | 162000 |
| Interquartile range (IQR) | 32500 |
Descriptive statistics
| Standard deviation | 30501.43401 |
|---|---|
| Coefficient of variation (CV) | 1.057519113 |
| Kurtosis | 2.813472926 |
| Mean | 28842.44233 |
| Median Absolute Deviation (MAD) | 11000 |
| Skewness | 1.736079317 |
| Sum | 1.0862756e+10 |
| Variance | 930337476.8 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 87100 | 3249 | 0.8% | |
| 6500 | 3168 | 0.8% | |
| 4100 | 3015 | 0.8% | |
| 3800 | 2991 | 0.8% | |
| 10400 | 2657 | 0.7% | |
| 2100 | 2598 | 0.7% | |
| 6300 | 2554 | 0.7% | |
| 13700 | 2422 | 0.6% | |
| 12100 | 2393 | 0.6% | |
| 9200 | 2390 | 0.6% | |
| Other values (1180) | 349187 | 91.1% | |
| (Missing) | 6621 | 1.7% |
| Value | Count | Frequency (%) | |
| 100 | 495 | 0.1% | |
| 200 | 387 | 0.1% | |
| 201 | 37 | < 0.1% | |
| 202 | 149 | < 0.1% | |
| 300 | 683 | 0.2% |
| Value | Count | Frequency (%) | |
| 162100 | 29 | < 0.1% | |
| 161700 | 153 | < 0.1% | |
| 157903 | 41 | < 0.1% | |
| 157902 | 125 | < 0.1% | |
| 157901 | 93 | < 0.1% |
| Distinct count | 20399 |
|---|---|
| Unique (%) | 5.4% |
| Missing | 8384 |
| Missing (%) | 2.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2513323.3370049163 |
|---|---|
| Minimum | 1000000.0 |
| Maximum | 5799501.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 1000000 |
|---|---|
| 5-th percentile | 1005449 |
| Q1 | 1044044 |
| median | 3008393 |
| Q3 | 4002472 |
| 95-th percentile | 4447721 |
| Maximum | 5799501 |
| Range | 4799501 |
| Interquartile range (IQR) | 2958428 |
Descriptive statistics
| Standard deviation | 1346335.526 |
|---|---|
| Coefficient of variation (CV) | 0.5356793956 |
| Kurtosis | -1.449867594 |
| Mean | 2513323.337 |
| Median Absolute Deviation (MAD) | 1184997 |
| Skewness | 0.1630198287 |
| Sum | 9.421468994e+11 |
| Variance | 1.812619349e+12 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 4000000 | 1763 | 0.5% | |
| 1000000 | 557 | 0.1% | |
| 1035381 | 489 | 0.1% | |
| 4113546 | 478 | 0.1% | |
| 4045999 | 438 | 0.1% | |
| 1012541 | 411 | 0.1% | |
| 4112276 | 399 | 0.1% | |
| 3000000 | 390 | 0.1% | |
| 5039658 | 352 | 0.1% | |
| 2000000 | 321 | 0.1% | |
| Other values (20389) | 369263 | 96.4% | |
| (Missing) | 8384 | 2.2% |
| Value | Count | Frequency (%) | |
| 1000000 | 557 | 0.1% | |
| 1000003 | 11 | < 0.1% | |
| 1000005 | 116 | < 0.1% | |
| 1000006 | 13 | < 0.1% | |
| 1000007 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5799501 | 111 | < 0.1% | |
| 5170408 | 1 | < 0.1% | |
| 5170220 | 1 | < 0.1% | |
| 5169029 | 7 | < 0.1% | |
| 5166713 | 4 | < 0.1% |
| Distinct count | 20044 |
|---|---|
| Unique (%) | 5.2% |
| Missing | 1040 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2403734955.1260633 |
|---|---|
| Minimum | 1.0 |
| Maximum | 5270000501.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1001980047 |
| Q1 | 1010450001 |
| median | 3001867501 |
| Q3 | 4001650006 |
| 95-th percentile | 4115160200 |
| Maximum | 5270000501 |
| Range | 5270000500 |
| Interquartile range (IQR) | 2991200005 |
Descriptive statistics
| Standard deviation | 1338922432 |
|---|---|
| Coefficient of variation (CV) | 0.5570174986 |
| Kurtosis | -1.358584989 |
| Mean | 2403734955 |
| Median Absolute Deviation (MAD) | 1065042536 |
| Skewness | 0.1382735616 |
| Sum | 9.187195185e+14 |
| Variance | 1.792713279e+18 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 3464 | 0.9% | |
| 4 | 1726 | 0.5% | |
| 3 | 1122 | 0.3% | |
| 2 | 775 | 0.2% | |
| 4142600001 | 660 | 0.2% | |
| 1012800001 | 489 | 0.1% | |
| 4050190005 | 478 | 0.1% | |
| 4018600100 | 438 | 0.1% | |
| 1007130001 | 411 | 0.1% | |
| 4049730016 | 399 | 0.1% | |
| Other values (20034) | 372243 | 97.1% | |
| (Missing) | 1040 | 0.3% |
| Value | Count | Frequency (%) | |
| 1 | 3464 | 0.9% | |
| 2 | 775 | 0.2% | |
| 3 | 1122 | 0.3% | |
| 4 | 1726 | 0.5% | |
| 5 | 257 | 0.1% |
| Value | Count | Frequency (%) | |
| 5270000501 | 111 | < 0.1% | |
| 5080470021 | 1 | < 0.1% | |
| 5080470016 | 7 | < 0.1% | |
| 5080460001 | 27 | < 0.1% | |
| 5080430019 | 1 | < 0.1% |
| Distinct count | 193 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 6621 |
| Missing (%) | 1.7% |
| Memory size | 2.9 MiB |
| MN17 | 22776 |
|---|---|
| MN23 | 11458 |
| MN13 | 10569 |
| MN24 | 10491 |
| MN27 | 9317 |
| Other values (188) |
| Value | Count | Frequency (%) | |
| MN17 | 22776 | 5.9% | |
| MN23 | 11458 | 3.0% | |
| MN13 | 10569 | 2.8% | |
| MN24 | 10491 | 2.7% | |
| MN27 | 9317 | 2.4% | |
| MN22 | 8726 | 2.3% | |
| MN19 | 8583 | 2.2% | |
| MN15 | 8022 | 2.1% | |
| QN22 | 7640 | 2.0% | |
| MN25 | 6912 | 1.8% | |
| Other values (183) | 272130 | 71.0% | |
| (Missing) | 6621 | 1.7% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.982723845 |
| Min length | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| CAMIS | DBA | BORO | BUILDING | STREET | ZIPCODE | PHONE | CUISINE DESCRIPTION | INSPECTION DATE | ACTION | VIOLATION CODE | VIOLATION DESCRIPTION | CRITICAL FLAG | SCORE | GRADE | GRADE DATE | RECORD DATE | INSPECTION TYPE | Latitude | Longitude | Community Board | Council District | Census Tract | BIN | BBL | NTA | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 50002262 | SOUTHEAST BAKERY | Brooklyn | 6821 | FORT HAMILTON PARKWAY | 11219.0 | 7186801188 | Chinese | 12/12/2019 | Violations were cited in the following area(s). | 06A | Personal cleanliness inadequate. Outer garment soiled with possible contaminant. Effective hair restraint not worn in an area where food is prepared. | Critical | 28.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.629009 | -74.011629 | 310.0 | 43.0 | 21000.0 | 3143040.0 | 3.057710e+09 | BK30 |
| 1 | 41031137 | STARBUCKS | Manhattan | 1500 | BROADWAY | 10036.0 | 2122217515 | Coffee/Tea | 07/27/2021 | Violations were cited in the following area(s). | 04N | Filth flies or food/refuse/sewage-associated (FRSA) flies present in facility’s food and/or non-food areas. Filth flies include house flies, little house flies, blow flies, bottle flies and flesh flies. Food/refuse/sewage-associated flies include fruit flies, drain flies and Phorid flies. | Critical | 24.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.756849 | -73.985973 | 105.0 | 4.0 | 11900.0 | 1022610.0 | 1.009960e+09 | MN17 |
| 2 | 41471964 | DRUNKEN HORSE | Manhattan | 225 | 10 AVENUE | 10011.0 | 2126040505 | American | 12/10/2019 | Violations were cited in the following area(s). | 06C | Food not protected from potential source of contamination during storage, preparation, transportation, display or service. | Critical | 12.0 | A | 12/10/2019 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.747910 | -74.004013 | 104.0 | 3.0 | 9900.0 | 1012354.0 | 1.006950e+09 | MN13 |
| 3 | 50053120 | DELICIAS MEXICANOS | Queens | 10214 | ROOSEVELT AVE | 11368.0 | 7186724485 | Mexican | 02/26/2019 | Violations were cited in the following area(s). | 02B | Hot food item not held at or above 140º F. | Critical | 30.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.749743 | -73.863819 | 404.0 | 21.0 | 40500.0 | 4437314.0 | 4.019740e+09 | QN26 |
| 4 | 41640846 | RANDOLPH BEER | Manhattan | 343 | BROOME STREET | 10013.0 | 2123343706 | American | 10/16/2017 | Violations were cited in the following area(s). | 09C | Food contact surface not properly maintained. | Not Critical | 33.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.719650 | -73.994769 | 102.0 | 1.0 | 4100.0 | 1006944.0 | 1.004700e+09 | MN24 |
| 5 | 41630632 | J J NOODLE | Manhattan | 19 | HENRY STREET | 10002.0 | 2125712440 | Chinese | 04/30/2018 | Violations were cited in the following area(s). | 08A | Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist. | Not Critical | 33.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.712854 | -73.996487 | 103.0 | 1.0 | 800.0 | 1003431.0 | 1.002800e+09 | MN27 |
| 6 | 50054342 | FINE BAKERY CITY INC | Manhattan | 303 | GRAND STREET | 10002.0 | 2129663318 | Bakery Products/Desserts | 08/21/2018 | Violations were cited in the following area(s). | 10B | Plumbing not properly installed or maintained; anti-siphonage or backflow prevention device not provided where required; equipment or floor not properly drained; sewage disposal system in disrepair or not functioning properly. | Not Critical | 26.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.717506 | -73.991771 | 103.0 | 1.0 | 1600.0 | 1003983.0 | 1.003070e+09 | MN27 |
| 7 | 50052591 | KAKUREGA JAPANESE CUISINE | Queens | 13344 | 37TH AVE | 11354.0 | 7188868668 | Japanese | 01/23/2019 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 23.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.760679 | -73.833428 | 407.0 | 20.0 | 87100.0 | 4532162.0 | 4.049720e+09 | QN22 |
| 8 | 50037148 | DUNKIN | Staten Island | 585 | VETERANS ROAD WEST | 10309.0 | 7186733298 | Donuts | 09/08/2021 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 7.0 | A | 09/08/2021 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.548477 | -74.221303 | 503.0 | 51.0 | 22600.0 | 5159203.0 | 5.071030e+09 | SI11 |
| 9 | 40921141 | ALBERTO'S | Queens | 9831 | METROPOLITAN AVE | 11375.0 | 7182687860 | Italian | 02/01/2019 | Violations were cited in the following area(s). | 15F6 | Workplace SFAA policy not prominently posted in workplace | Not Critical | NaN | NaN | NaN | 11/07/2021 | Smoke-Free Air Act / Initial Inspection | 40.710905 | -73.853662 | 406.0 | 29.0 | 72900.0 | 4076686.0 | 4.032070e+09 | QN17 |
Last rows
| CAMIS | DBA | BORO | BUILDING | STREET | ZIPCODE | PHONE | CUISINE DESCRIPTION | INSPECTION DATE | ACTION | VIOLATION CODE | VIOLATION DESCRIPTION | CRITICAL FLAG | SCORE | GRADE | GRADE DATE | RECORD DATE | INSPECTION TYPE | Latitude | Longitude | Community Board | Council District | Census Tract | BIN | BBL | NTA | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 383235 | 40931929 | FRANKIE & JOHNNIE'S STEAKHOUSE | Manhattan | 32 | WEST 37 STREET | 10018.0 | 2129478940 | Steakhouse | 03/16/2017 | Violations were cited in the following area(s). | 04M | Live roaches present in facility's food and/or non-food areas. | Critical | 12.0 | A | 03/16/2017 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.750830 | -73.984368 | 105.0 | 4.0 | 8400.0 | 1015948.0 | 1.008380e+09 | MN17 |
| 383236 | 50065362 | THE GREAT AMERICAN BAGEL BAKERY | Manhattan | 200 | BROADWAY | 10038.0 | 6465967105 | American | 05/08/2018 | Violations were cited in the following area(s). | 04A | Food Protection Certificate not held by supervisor of food operations. | Critical | 32.0 | C | 05/08/2018 | 11/07/2021 | Pre-permit (Operational) / Re-inspection | 40.710526 | -74.009353 | 101.0 | 1.0 | 1502.0 | 1089384.0 | 1.000790e+09 | MN25 |
| 383237 | 50042450 | EGGER'S ICE CREAM PARLOR | Staten Island | 1194 | FOREST AVENUE | 10310.0 | 7189816534 | Frozen Desserts | 04/09/2018 | Violations were cited in the following area(s). | 08A | Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist. | Not Critical | 21.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.626447 | -74.129757 | 501.0 | 49.0 | 15100.0 | 5009718.0 | 5.003540e+09 | SI07 |
| 383238 | 50037651 | SABOR TROPICAL | Manhattan | 143 | SHERMAN AVENUE | 10034.0 | 2123045144 | Latin American | 07/13/2016 | Violations were cited in the following area(s). | 04N | Filth flies or food/refuse/sewage-associated (FRSA) flies present in facility’s food and/or non-food areas. Filth flies include house flies, little house flies, blow flies, bottle flies and flesh flies. Food/refuse/sewage-associated flies include fruit flies, drain flies and Phorid flies. | Critical | 24.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.864534 | -73.923368 | 112.0 | 10.0 | 29100.0 | 1064764.0 | 1.022210e+09 | MN01 |
| 383239 | 50010628 | GREENPOINT FISH & LOBSTER CO. | Brooklyn | 114 | NASSAU AVENUE | 11222.0 | 7183490400 | Seafood | 07/24/2018 | Violations were cited in the following area(s). | 06A | Personal cleanliness inadequate. Outer garment soiled with possible contaminant. Effective hair restraint not worn in an area where food is prepared. | Critical | 7.0 | A | 07/24/2018 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.724280 | -73.949202 | 301.0 | 33.0 | 57100.0 | 3066776.0 | 3.026810e+09 | BK76 |
| 383240 | 50068847 | 52ND SUSHI | Queens | 5221 | ROOSEVELT AVE | 11377.0 | 7185079204 | Japanese | 05/25/2019 | Violations were cited in the following area(s). | 10B | Plumbing not properly installed or maintained; anti-siphonage or backflow prevention device not provided where required; equipment or floor not properly drained; sewage disposal system in disrepair or not functioning properly. | Not Critical | 13.0 | A | 05/25/2019 | 11/07/2021 | Cycle Inspection / Re-inspection | 40.744256 | -73.912196 | 402.0 | 26.0 | 25302.0 | 4030800.0 | 4.013150e+09 | QN31 |
| 383241 | 50066349 | SWEET CHICK | Brooklyn | 636 | CARLTON AVENUE | 11238.0 | 7184847724 | American | 05/21/2019 | Violations were cited in the following area(s). | 02G | Cold food item held above 41º F (smoked fish and reduced oxygen packaged foods above 38 ºF) except during necessary preparation. | Critical | 12.0 | A | 05/21/2019 | 11/07/2021 | Cycle Inspection / Re-inspection | 40.677575 | -73.972312 | 308.0 | 35.0 | 16100.0 | 3028687.0 | 3.011570e+09 | BK64 |
| 383242 | 50011214 | THE CRABBY SHACK | Brooklyn | 613 | FRANKLIN AVENUE | 11238.0 | 7184841570 | Seafood | 05/16/2019 | Violations were cited in the following area(s). | 08A | Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist. | Not Critical | 11.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.677400 | -73.955526 | 308.0 | 35.0 | 22100.0 | 3030246.0 | 3.012110e+09 | BK61 |
| 383243 | 50011892 | ROBUSTA ESPRESSO BAR | Manhattan | 50 | WEST 47 STREET | 10036.0 | 2123020242 | Coffee/Tea | 09/01/2021 | Violations were cited in the following area(s). | 08A | Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist. | Not Critical | 34.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.757326 | -73.980187 | 105.0 | 4.0 | 9600.0 | 1034346.0 | 1.012628e+09 | MN17 |
| 383244 | 50013768 | SUBWAY CAFE | Manhattan | 351 | WEST 42 STREET | 10036.0 | 2129918945 | Sandwiches | 12/06/2017 | Violations were cited in the following area(s). | 02G | Cold food item held above 41º F (smoked fish and reduced oxygen packaged foods above 38 ºF) except during necessary preparation. | Critical | 17.0 | NaN | NaN | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.757841 | -73.991229 | 104.0 | 3.0 | 12100.0 | 1024937.0 | 1.010330e+09 | MN15 |
Most frequent
| CAMIS | DBA | BORO | BUILDING | STREET | ZIPCODE | PHONE | CUISINE DESCRIPTION | INSPECTION DATE | ACTION | VIOLATION CODE | VIOLATION DESCRIPTION | CRITICAL FLAG | SCORE | GRADE | GRADE DATE | RECORD DATE | INSPECTION TYPE | Latitude | Longitude | Community Board | Council District | Census Tract | BIN | BBL | NTA | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | 40356483 | WILKEN'S FINE FOOD | Brooklyn | 7114 | AVENUE U | 11234.0 | 7184443838 | Sandwiches | 05/03/2019 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 13.0 | A | 05/03/2019 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.620112 | -73.906989 | 318.0 | 46.0 | 70000.0 | 3237693.0 | 3.084310e+09 | BK45 | 3 |
| 6 | 40359705 | NATHAN'S FAMOUS | Brooklyn | 1310 | SURF AVENUE | 11224.0 | 7183332202 | Hotdogs | 03/07/2018 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 10.0 | A | 03/07/2018 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.575537 | -73.981652 | 313.0 | 47.0 | 35200.0 | 3189660.0 | 3.070740e+09 | BK21 | 3 |
| 20 | 40363685 | BERKELEY | Manhattan | 437 | MADISON AVENUE | 10022.0 | 2128328121 | American | 07/25/2017 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 9.0 | A | 07/25/2017 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.757512 | -73.975827 | 105.0 | 4.0 | 10200.0 | 1035455.0 | 1.012850e+09 | MN17 | 3 |
| 29 | 40364518 | 7B BAR | Manhattan | 108 | AVENUE B | 10009.0 | 2126776742 | American | 06/05/2018 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 10.0 | A | 06/05/2018 | 11/07/2021 | Cycle Inspection / Re-inspection | 40.724985 | -73.981283 | 103.0 | 2.0 | 3200.0 | 1005094.0 | 1.004020e+09 | MN22 | 3 |
| 32 | 40364581 | JUNIOR'S | Brooklyn | 386 | FLATBUSH AVENUE EXTENSION | 11201.0 | 7188525257 | American | 01/24/2019 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 12.0 | A | 01/24/2019 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.690200 | -73.981624 | 302.0 | 33.0 | 1500.0 | 3000369.0 | 3.001490e+09 | BK38 | 3 |
| 38 | 40365239 | DORRIAN'S RED HAND RESTAURANT | Manhattan | 1616 | 2 AVENUE | 10028.0 | 2127726660 | Irish | 11/08/2018 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 11.0 | A | 11/08/2018 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.776405 | -73.952802 | 108.0 | 5.0 | 13800.0 | 1049947.0 | 1.015460e+09 | MN32 | 3 |
| 62 | 40366230 | DON PEPPE | Queens | 13558 | LEFFERTS BOULEVARD | 11420.0 | 7188457587 | Italian | 09/13/2018 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 13.0 | A | 09/13/2018 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.670258 | -73.820976 | 410.0 | 32.0 | 83800.0 | 4256605.0 | 4.118050e+09 | QN55 | 3 |
| 71 | 40366473 | TIO PEPE | Manhattan | 168 | WEST 4 STREET | 10014.0 | 2122429338 | Seafood | 06/19/2019 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 7.0 | A | 06/19/2019 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.732057 | -74.001443 | 102.0 | 3.0 | 6700.0 | 1010145.0 | 1.005900e+09 | MN23 | 3 |
| 100 | 40367841 | CAFE FIORELLO | Manhattan | 1900 | BROADWAY | 10023.0 | 2125955330 | Italian | 03/10/2020 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 13.0 | A | 03/10/2020 | 11/07/2021 | Cycle Inspection / Re-inspection | 40.771511 | -73.982150 | 107.0 | 6.0 | 14900.0 | 1027472.0 | 1.011168e+09 | MN14 | 3 |
| 115 | 40368577 | DENNY'S PUB | Brooklyn | 106 | BEVERLY ROAD | 11218.0 | 7184352156 | American | 07/26/2018 | Violations were cited in the following area(s). | 10F | Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical | 12.0 | A | 07/26/2018 | 11/07/2021 | Cycle Inspection / Initial Inspection | 40.642932 | -73.978870 | 312.0 | 39.0 | 48600.0 | 3125226.0 | 3.053530e+09 | BK41 | 3 |